SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017147 LIMIT 1 [ RunTime:0.000750s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017147 [ RunTime:0.002142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113109,783181,980777,269894,146474,119803,1023279,639702,404567,867950,403622,174033,291377,115086,54936,498440,395692,1038460,688357,202930,946749,1012541,224087,995294,937414,376177,56779,804368,719857,408049,36979,513143,250221,462457,544479,121451,220806,422361,780898,6105,231994,137978,742713,483311,73179,380314,1040190,419010,580272,52535,680428,132175,708,31710,893818,646349,565766,796070,68768,194551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]