SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043993 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043993 [ RunTime:0.007337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15345,786174,997033,286866,536084,36256,767369,843028,79165,40048,1000223,923769,638547,922433,127592,263352,156734,372471,932916,146132,681774,444734,861735,472661,772434,1031477,465447,575501,332320,1027549,991940,973998,829230,541374,870342,421360,674289,525893,992432,417615,826018,217747,586190,93841,496787,158494,209932,603999,613999,411990,444476,301000,386616,597233,148883,587883,992065,597966,815767,81099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002082s ]