SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406057 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406057 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209809,843756,236384,820827,250690,800850,878785,69834,728046,933371,693178,281766,1001615,663059,48510,64883,255539,265977,374208,903557,810721,171899,621038,1021080,757872,890439,576901,628444,845742,33748,171510,83858,452703,540809,717067,57508,971869,821808,559030,415167,282698,383293,185794,973341,952139,827455,765693,436013,298154,521736,654531,269169,973014,1012546,434951,809176,920297,267821,941934,506518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]