SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41213 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41213 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112522,702514,431365,123945,900863,199381,971091,269726,560261,1006170,365932,322226,536976,112734,620236,650124,535370,727820,684874,558974,552122,381313,718890,147619,226094,902787,1015944,426541,483079,534506,920858,677739,940571,980638,29282,772330,587231,115349,869824,1029597,692381,180049,291219,212495,433789,402545,33307,156785,540361,32493,678186,646691,503216,57958,531023,101367,732339,452859,86644,192054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]