SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151401 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151401 [ RunTime:0.002293s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481513,499771,91444,1012930,387914,135962,391862,605892,917077,487643,257197,671383,76158,665035,503880,68816,223477,290522,805595,618409,285321,119820,884362,308506,552350,580076,215225,957162,460774,1023180,584541,983442,422186,266461,388494,516781,758088,923821,803169,703208,780848,957679,656494,682475,147421,964645,818127,93146,116378,10485,571738,990155,28372,710687,293849,232112,322749,1021850,720106,567445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001374s ]