SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023040 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023040 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492414,124785,396593,89497,242541,651288,964681,894800,231617,892046,552034,903957,124438,828862,59983,245729,650826,120016,494002,679429,361460,162950,467209,938849,51349,819760,436629,859660,211998,552591,147753,335905,314666,701411,377655,429107,489931,890570,987768,490339,349525,101697,741730,504579,352830,842766,169008,803781,192109,69680,737180,377786,987593,510787,27588,26666,952696,743549,285452,356049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]