SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427583 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427583 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295882,525035,182932,466046,298706,1041110,363058,1041484,900537,1024781,325293,922328,54788,899762,991593,150598,333309,281650,997360,214345,1001026,990645,986751,92040,417682,17224,625040,333413,461581,520423,454951,780020,920388,33437,129893,56967,482264,70389,590137,843153,907613,179061,697902,653443,167794,458013,121854,94,59116,349352,255910,159318,361611,578611,799094,961172,223689,149140,39202,925840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]