SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021365 LIMIT 1 [ RunTime:0.002467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021365 [ RunTime:0.003447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013302,542636,784189,588804,917120,280560,836685,83996,19812,51039,43602,325453,236933,70823,214700,15072,862651,749378,1040786,294688,126945,973839,806161,434603,1046483,798632,1006134,931309,1035765,59824,273410,542112,820035,878671,591285,342677,854305,892391,968334,370988,914575,789416,32692,782006,768798,711004,722007,349754,375337,738193,284289,289550,284756,905206,295320,1012682,87686,323237,693664,662205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]