SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003893s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270312 LIMIT 1 [ RunTime:0.000788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270312 [ RunTime:0.006473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275826,561855,693699,655185,12193,485870,522947,907454,610744,123605,573469,15929,199054,730309,43881,114480,131318,589362,338151,167246,89801,277698,467594,697780,548286,572830,327091,483821,316785,582469,182383,651050,98983,510953,369886,37170,246108,90898,43891,871834,187900,154379,600081,471560,86292,688720,657114,450452,651652,553528,857316,34865,94886,5384,747544,879586,409956,329577,806744,835686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006673s ]