SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801716 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801716 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692105,837575,280264,812958,725308,296320,575048,678417,892630,389918,972137,361581,348405,876516,901529,392516,1020508,373829,1045154,40034,725559,1000647,871930,357347,559036,248234,444283,849937,59793,675441,6765,376837,669724,581827,249011,723462,852629,271477,684504,849613,327148,722306,113809,732983,570242,344277,709710,692651,992084,964108,802310,271952,618102,987551,982999,952278,789548,475385,942982,863007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]