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` = 404743 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404743 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323279,295581,831604,527577,574489,608712,713521,145412,150634,952003,210311,966738,613948,788504,462756,651261,349313,477074,1007452,721626,772173,170146,295438,548776,170524,865411,243986,1040707,76549,600482,434103,943042,426103,738806,165973,1017689,584173,565172,176239,781674,411654,618172,163442,638454,1014480,490737,381238,365353,495265,900349,837137,57070,638193,47253,388092,492064,889873,460242,254538,437382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]