SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34649 LIMIT 1 [ RunTime:0.000749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34649 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606342,476197,930953,937246,895767,420824,984933,706939,711728,794861,800389,300536,462720,368657,873642,526515,383677,683453,101059,645475,137669,827209,293585,898173,631608,94536,695679,601699,602770,1044526,641214,939796,993212,151337,521968,830931,972945,634322,402112,430428,614549,835401,225831,986515,190158,530855,120708,795820,668202,495479,1040802,30657,202824,768984,288646,434684,823715,84120,558116,770028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]