SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048455 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048455 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734184,913736,357230,102134,884801,23013,700304,462010,179217,751437,827511,952250,272512,720175,822179,683911,804873,882213,365266,622983,515791,424707,581076,537275,791032,201685,254949,93285,940071,21063,333101,1042109,220891,118337,700905,279301,449030,806009,106459,873148,815371,313174,15050,757160,66230,79202,784585,146274,446384,642370,644068,122904,551042,974069,337443,614076,552138,542954,497924,429193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]