SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541924 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541924 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856099,336411,305757,615102,350695,265630,538402,550190,238652,866219,395402,1026648,207281,653659,762743,396742,859534,433959,269172,263289,980138,360914,331248,810666,482378,95545,1026916,981787,584081,67523,606012,410639,311256,514307,841107,48295,949239,723619,434523,574865,19182,82602,804404,420758,242079,20534,492883,90504,407615,859293,169594,493442,90785,371466,279484,965050,1014209,733017,148643,833095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003288s ]