SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565284 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565284 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173108,1026139,144200,850673,1029509,967234,33084,304334,318141,810724,617249,840467,466505,908201,677374,726199,390146,214268,478440,913581,247073,107065,534904,865929,1033442,359914,691994,840176,175098,613906,463099,143708,1035686,1041344,283370,651512,311043,50490,120185,1044152,135179,1029425,125631,420202,582160,607512,220242,941233,563615,875646,918561,753043,783490,529963,236849,245300,853781,1034928,280186,885753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]