SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538198 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538198 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183848,724981,3338,566762,789730,962131,436313,19976,298723,914261,361834,523359,336065,1039782,915410,187057,638661,170626,123284,972671,345685,353712,773459,300972,1008124,517754,220507,330828,131354,733895,406344,291982,27456,281661,978970,518200,322737,644978,82833,1025663,16627,662398,824380,291719,267786,560578,134251,453925,864853,692050,781408,226975,995584,999812,868861,774188,1046721,923234,66096,154580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]