SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284328 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284328 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628393,740034,814974,747842,75921,593103,453735,27285,19412,584105,333192,338724,470584,769068,149796,657845,423461,536819,210296,1036517,144429,371236,740300,648261,650130,494867,243851,963502,662371,448045,46428,168511,117722,163432,166891,367727,391866,52576,867037,313176,980908,760210,178737,309248,224230,423212,363817,1014308,962430,886569,846545,435924,912401,874716,680365,510181,1001054,934120,998658,142009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]