SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567881 LIMIT 1 [ RunTime:0.001250s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567881 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851813,178128,942817,221204,779525,219001,1034103,116985,218629,901215,90617,703492,336249,804644,388737,714308,513738,162636,69000,752029,940004,581323,144515,296829,822246,190932,668087,928233,16253,856272,437798,902385,372680,587107,441323,203933,731957,196752,18370,333683,719786,434323,716812,646374,196012,54886,879573,364136,282837,1027261,196706,978282,870076,801153,957640,312929,291278,692725,447538,584611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002748s ]