SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109934 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109934 [ RunTime:0.002866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536791,283242,795117,314275,859909,938796,322511,377125,171478,497600,761315,106,725628,655745,760005,415325,128980,686100,735768,373714,71596,456363,57064,717033,74165,105878,992202,760627,466234,228439,67328,1010027,92788,823226,447742,28097,937897,663329,986649,978373,276745,264412,363262,364514,335003,860547,27174,788320,67042,534076,382819,239719,345022,126674,578760,383939,96436,1010598,715311,22689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001218s ]