SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538620 LIMIT 1 [ RunTime:0.002309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538620 [ RunTime:0.003963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183795,930606,489040,673408,854483,814206,190762,495186,735873,161436,336386,694214,560789,232816,135365,336067,560228,506673,466807,474906,526610,196897,382347,17296,32631,499274,236018,230484,787282,630830,283927,751263,577059,713577,579805,491513,174078,214433,352724,328078,299893,268453,721950,965339,1004164,980699,165374,96885,487250,303415,160213,985253,90231,408858,637569,431026,36702,234167,49825,904937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]