SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392218 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392218 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607627,492457,200761,903602,455921,110696,130606,30849,192219,984470,886662,427656,1032043,1009132,402360,535212,697831,798181,891666,720750,955687,545958,814667,141455,146813,145747,858202,569863,731474,205261,951220,22005,917697,988885,561338,466525,650919,180483,756620,696098,203338,261808,488665,204697,491447,252625,817241,262486,624117,633887,766135,1014040,888625,131275,489461,170076,712855,33030,583858,593640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]