SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4182 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4182 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112015,562192,1001782,118928,293854,827475,419866,560874,483564,121482,842003,1004110,739392,367104,341832,88931,573581,1045923,735218,440860,870723,198395,152504,754942,305193,1001738,1014211,761704,729539,284272,895649,181149,770661,402155,21162,180100,974689,941559,803522,38476,397863,89044,170850,869215,93586,303901,681312,218374,521311,585257,241142,162533,496669,66324,510344,93779,916458,907393,7461,104234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]