SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403443 LIMIT 1 [ RunTime:0.001466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403443 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002550,801702,214640,470695,9888,791950,514370,985703,463652,847260,438813,309465,786639,728919,156820,593239,29698,726321,678328,196703,460631,120988,935344,598818,959035,869476,929944,801635,378891,833827,739059,116342,236975,931129,455547,57806,762995,647158,770583,847130,248576,318492,696161,496276,29585,379070,842559,989501,652375,88021,196303,458784,771060,831086,968375,817400,992797,71386,848536,614290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]