SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411201 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411201 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839901,1007808,818419,1019470,59720,391372,660953,548660,131569,661342,192462,1009095,898117,455923,773584,720844,174473,325225,933618,129644,961144,844278,702949,120729,148051,129889,881791,322527,438066,282650,966408,693801,124221,126233,990563,703005,51016,376606,976306,557371,623131,503090,262206,477174,595291,999871,612999,482521,433184,1410,928272,121004,149811,691141,804153,688087,407971,391859,36557,142816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]