SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526449 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526449 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838482,251505,214273,714564,102203,432584,75880,966716,685145,1045315,1043778,120470,330897,808780,787674,554542,185295,721925,310922,520861,898893,596034,638857,472132,196580,125725,599457,892155,430391,455647,584149,450382,985593,12818,682678,424281,259124,410481,342164,1014173,16832,592040,645819,838616,783224,164170,235283,237066,330682,874544,795093,290278,812424,562408,90733,592866,447774,127179,889354,142034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]