SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026042 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026042 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424127,763977,1034427,543839,925266,56795,175241,852637,1023232,520400,712030,114736,676366,448930,236803,105318,142558,331972,948765,219280,322802,604940,411195,196369,870996,985155,668117,1011225,395337,400532,886147,832346,651791,571926,746915,478185,383660,933091,955861,734625,666367,82000,1035729,308146,129234,31379,1025814,332542,626761,816173,765306,670037,772487,545108,248547,750342,1011340,576522,672935,553337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]