SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316380 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316380 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759367,462706,780039,376209,18715,87552,826506,850862,604386,472245,778096,290666,27196,446120,472216,931402,54463,948951,560413,1038627,229328,720105,356303,169318,493053,970957,611637,928033,239245,309738,158996,750471,489215,854283,2572,1039933,447177,133381,283201,849083,683967,959294,199262,987528,271546,295939,892449,307210,382652,1013748,68324,67857,800740,170695,361774,760426,341514,678990,251984,458904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002410s ]