SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583691 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583691 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710848,392809,50915,276421,1026449,575603,606771,662137,416540,104095,473161,403090,668680,334245,1007928,19186,269924,536948,110405,1029231,517326,794550,1001131,774520,534791,247344,772464,137297,463718,239423,142633,985727,265850,690668,1984,764974,78074,360037,28030,89572,72989,463051,343399,626252,700521,528489,239961,417218,519821,75484,20712,428696,1021330,834795,678308,808457,772444,851644,12424,569285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]