SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401322 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401322 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66053,545680,995622,905569,730902,812586,1001011,794687,492826,664490,701985,233188,967631,859085,552432,367257,1031291,909793,881372,43700,482240,592114,608852,960838,473314,861782,437829,235107,410658,296671,1045717,837851,840646,76689,515338,256479,1001334,267116,381341,20768,722046,680776,955792,737374,144198,646931,794545,774408,740602,928348,529559,635056,973187,281906,332594,441314,653556,950686,849489,117137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]