SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541807 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541807 [ RunTime:0.001291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363068,148326,1025989,473808,50101,910575,609271,721946,223368,30621,392543,838190,92781,139707,973049,772177,854307,464604,587917,130390,355275,740002,620891,870181,18159,841724,428151,393920,395409,1046009,721115,556006,309200,73948,448035,708193,386288,919584,182732,969573,77485,709999,1009044,288491,213181,76264,134834,843850,1037118,134718,894273,974408,286012,34826,367345,308614,24660,415437,355893,321437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003586s ]