SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402912 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402912 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711090,606736,351061,870395,612912,461990,55264,87416,638120,532835,547074,933080,684553,515960,216225,962240,262066,711762,951358,143683,788558,529864,71257,452618,684640,603968,4610,272219,719484,920462,12880,370883,566503,457128,470214,853048,496253,904254,45959,751189,1048623,685535,1003166,886673,994999,34000,338915,54754,731895,789097,482590,9084,916559,960499,542180,202799,720243,617032,514821,393390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]