SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 927180 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 927180 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181617,812410,620715,72189,346887,417999,160994,1167,532115,832474,800772,331440,321879,796353,426008,257104,927280,155050,676300,874263,261663,202944,58256,527139,86330,693073,639807,75760,328488,903125,773154,56074,127467,310503,543613,70234,1015756,320932,456081,279709,816677,470041,982447,604692,515494,689655,193329,503288,365072,1015786,271611,689968,338934,707376,157538,266531,49470,898077,373606,742907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 927180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 927180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]