SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002751s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5078 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5078 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633403,961300,726847,758847,97489,174125,797851,842925,755653,522451,789360,556427,153591,652684,599197,314553,478001,449206,768585,141067,416916,449551,399086,145332,825539,889407,224411,291611,514905,809173,922627,863747,581018,619828,813553,77888,182132,629609,110283,703803,976324,307269,406911,534059,974104,318095,799314,381429,496487,671164,1025780,842488,807351,642395,1023267,65376,800174,598023,256973,157386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]