SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504802 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504802 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244827,72490,176793,846113,270860,277888,786751,752397,682487,802963,59554,342086,388368,427468,721100,119461,446706,1047235,203353,636043,828540,654687,970971,834879,725823,456332,240221,404338,986689,328915,951430,603639,765637,600701,765003,184121,996768,373192,661972,502299,352025,211002,712234,774534,606722,575112,249423,265301,808115,502992,443609,150512,849543,357618,226067,386738,410149,705709,483777,917903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]