SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465878 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465878 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385204,197876,879253,618665,1038732,234481,324023,553174,299198,333820,759785,1000942,930636,27259,743418,998478,561698,636038,135103,362711,258822,829436,375134,659824,904634,219733,40037,1008405,873023,963184,986366,924910,142066,1016094,277169,265270,648860,899826,847571,565873,768209,593329,536354,26252,297272,1027521,163782,123755,306874,374112,689022,39868,234993,468561,28748,463229,320887,278902,350653,714223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]