SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417435 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417435 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754019,960273,1020144,220615,1002719,824303,674841,968592,156053,244384,970555,646806,471517,631014,703542,632769,777154,810121,600428,551208,472905,767661,356806,18978,169335,977301,171420,898559,1012392,433982,446179,489655,897423,787810,926438,870399,825183,921142,590581,683878,54583,273905,982335,225220,671842,68903,692740,91575,764146,961197,961667,821794,121217,255726,231760,862685,48098,918494,632671,127629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]