SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030302 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030302 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753478,446602,586974,51085,968261,350973,818319,722483,380438,19908,860651,104087,967997,143418,114611,441013,638558,238398,123311,160247,363435,1041003,809151,185801,301261,655662,452304,14840,153250,574857,767737,922438,597766,675831,194757,894745,518233,598009,293104,152324,321407,118057,216379,830298,244650,137635,784072,108602,1046631,877710,463815,9651,702744,371625,380189,1015237,835771,684431,952377,972570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]