SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403476 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403476 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83504,333491,107650,930736,483005,1041732,346033,32027,869775,1014858,986577,299109,784438,642732,84558,745467,865283,473846,182076,845639,1037376,448007,979715,837740,724481,641192,999577,282995,348043,753778,904023,549904,900416,274870,789941,486226,152448,613036,229291,676590,250191,444890,269248,931511,466823,675956,634099,944052,647192,690897,992440,191314,659605,661944,1038990,901836,1038290,1025569,428144,490861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002644s ]