SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465509 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465509 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64027,190447,35854,589542,431633,380128,742497,52102,347911,199066,248601,1000429,385300,1027635,920294,841937,449174,568720,403040,199742,929275,1016048,795667,848203,212737,321070,828463,101837,265460,591466,276795,142865,829567,1010282,983190,693775,508134,316593,639114,405546,923442,614143,71928,910680,536354,169035,330373,778878,40380,990778,592734,852109,955635,327904,593110,738600,210693,119064,630707,250351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]