SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389674 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389674 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553773,154075,1005787,767093,120673,891760,498972,378092,886467,849191,122921,631825,993994,350040,58755,973503,974471,942744,901912,885658,722108,752333,331798,853811,236460,882347,161653,524682,797142,952697,963594,417162,58599,964842,740773,824732,573991,261969,207903,789155,892023,782165,305671,813518,651505,809041,50235,416868,240940,63106,492202,704491,948968,744668,636581,984960,767761,68333,718736,180626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]