SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536941 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536941 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249814,901509,857380,712655,520176,635368,274201,435265,1023074,338837,224341,638006,675524,347321,332653,326611,384978,954973,825619,553092,130373,1011336,728976,578720,907055,599369,638622,986574,109082,554617,974475,765551,549383,705443,262307,722523,918469,411383,931741,350815,501016,86537,615340,200549,4377,353015,885555,309892,826684,69104,18043,381956,997503,196419,582290,521089,234448,553165,600281,266259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]