SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98 [ RunTime:0.008875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529084,207979,163703,128507,668810,726981,992814,872537,896822,298223,599109,884788,984506,3613,449050,191784,389283,531806,494984,1031833,361800,550440,763704,503496,646134,848915,246165,123069,879622,772707,641820,49012,530922,15572,286433,81790,154384,774998,203980,537710,744592,664373,567594,852182,21720,1029699,787353,894388,666533,903183,3224,207813,317900,612698,606652,897206,678676,1032165,40317,125946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]