SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047283 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047283 [ RunTime:0.002630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670628,249603,791834,812532,877607,541587,534877,235453,64315,675936,199839,375980,760681,872279,241483,280173,52994,449306,289235,1040288,188419,865662,716508,392586,275589,453455,635915,1007654,351170,253930,905896,1007464,205260,574375,961356,13896,547832,506027,725339,254832,400806,281068,136240,251069,150171,499895,346382,445885,159724,693175,885624,976892,91515,561273,645765,551055,31239,549881,984900,246265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]