SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50584 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50584 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543068,801599,714972,142206,650593,1040817,495567,977442,751361,229609,526467,501304,493992,135725,971265,410974,180732,450886,1024016,528369,641244,31239,124271,846599,1019914,397931,88498,402087,355995,951643,630019,178492,637049,848661,794063,726268,189573,966800,185310,718916,961839,231603,1034929,933018,718298,999769,186939,879820,625127,440788,428235,98459,820713,610618,940594,1031824,43825,510284,604872,548972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002121s ]