SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418857 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418857 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677686,763627,415767,797907,72209,73640,898143,470433,1030094,320904,436532,405505,722851,572434,240868,538562,363603,537658,659453,828258,421986,660732,902347,284460,1043967,137375,991439,657985,860369,1042870,1007638,425746,181034,174370,901687,984725,457203,712509,959352,704155,818744,698573,969870,59702,794087,116308,461177,473609,950411,433141,1000195,824559,157861,474961,781396,833123,812802,616170,455724,881317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]