SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587733 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587733 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709405,222116,495060,828893,535563,618678,108369,607706,132295,840604,92401,898578,197996,197281,256581,331855,547158,283934,236168,555395,990969,337123,210698,516931,138985,369001,1043091,740685,312862,646281,180180,313478,625688,45206,84982,628163,550364,355520,629453,381830,805318,834123,777727,420932,804375,244665,47058,487844,237488,397102,686711,491421,16047,536662,390907,1028532,74280,529794,836024,115097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]