SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023180 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023180 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630310,535242,457194,179674,78529,22123,169622,725615,933003,626228,673340,668094,670707,835688,908531,622119,320242,177722,208789,506900,656430,674223,478181,423933,441679,481810,992244,26114,248880,811682,441249,176175,340026,323930,53381,953782,231619,283202,799909,78665,417055,546350,490973,940804,480657,552917,470370,864745,129851,662863,579771,738042,160959,406693,829909,710898,211254,828111,322231,763546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]