SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154848 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154848 [ RunTime:0.002865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911893,635056,411298,886902,661920,751293,765528,957419,41295,1026813,1030839,271887,169897,474583,81048,656235,243721,219921,793004,567929,3496,119681,508359,100430,828237,852981,959801,439601,355360,420409,316453,593222,326586,627741,572188,378012,270051,763026,603903,267256,104174,769678,124223,989434,527816,10643,317179,759866,80664,535263,492745,364933,470900,821362,244776,823000,984914,428238,982722,922310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]