SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493010 LIMIT 1 [ RunTime:0.005384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493010 [ RunTime:0.009492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550801,256967,511174,972615,648147,15312,935357,736141,801938,672984,347266,290901,905337,813720,523412,1027727,434346,481772,480156,340831,568580,648668,462256,1039050,518230,418472,599705,1013141,354318,294891,848198,780023,333588,261676,765785,339601,593824,554459,765092,781404,783833,961779,1017440,551966,327591,30940,766808,293863,322028,84013,683596,790586,700278,976104,365893,871418,553990,717378,706549,675248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]