SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444183 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444183 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277503,723435,633042,669503,390589,384323,218575,403935,962368,185459,1038739,860658,36676,520996,85625,70710,457497,27570,846507,324128,685246,525215,522627,1031844,923810,642261,556305,759785,524592,857383,558889,900155,863564,303308,188102,823198,839274,835416,66539,617822,766332,972558,623422,428540,102969,927013,398996,574404,972953,304661,371410,173108,435592,147128,663578,804166,959141,962562,14299,428718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]