SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042307 LIMIT 1 [ RunTime:0.001448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042307 [ RunTime:0.006013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443850,712428,412400,185349,961011,682718,3178,59507,745632,208944,314445,266385,1029068,582889,372773,582457,884130,988943,900551,423115,893677,297676,560504,806263,262338,302395,307798,924388,512718,780466,283332,858281,232204,886255,27667,290132,81272,759626,927621,954658,412415,771379,847956,867402,432835,308453,588123,304557,538673,525936,633958,827623,947115,197143,800532,973657,73765,68892,472269,127533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]