SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54054 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54054 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87152,1024221,525683,446544,1025181,46007,852504,656508,347416,455230,76068,275941,381577,1019819,458765,840087,91888,558406,980916,640210,587737,782889,292121,807645,228980,398839,5394,575254,86389,955635,809774,43040,555514,524475,170307,267738,153015,74484,511314,254825,180474,361198,22816,796260,162163,855423,336275,773317,823234,33987,458192,804172,328501,767710,498089,794932,938680,711530,628509,806213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]