SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046810 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046810 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048165,29943,822382,370874,460241,754547,912267,476909,825080,432829,5310,280424,81457,933464,635937,626691,669752,105440,254083,133999,736606,244588,41696,350523,903782,624079,262431,284408,278483,160061,492561,937791,504182,965204,311961,938556,427487,713363,1030697,935794,176160,399548,226349,569293,28685,981935,708225,168957,997950,409659,940485,332788,521952,524500,827314,291389,201451,870997,113884,75823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]