SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201340 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201340 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534531,160823,759519,313111,218854,183816,271825,1035742,322787,896832,463098,538616,163496,831403,807980,932609,852874,748486,607095,437090,324953,836708,701244,166038,823520,383901,361378,899823,439656,801455,205714,94408,797043,220144,138771,183133,453470,622413,255194,62196,411005,232623,307779,131625,32397,238183,952884,117229,500786,664431,191919,757005,133279,83486,963138,571847,522948,668717,280239,623688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]