SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496509 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496509 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288987,466247,824815,495760,316647,118496,878412,474151,384755,841326,713438,480876,226161,690760,789751,975529,666789,878911,313568,84657,389186,638937,886532,404533,372016,611624,797385,633900,61307,512941,453135,946821,759738,933675,629278,968255,53742,518849,206144,258523,929467,797474,101858,166815,160144,703474,438922,485970,988972,961714,621147,672319,222813,272833,895361,835862,926447,305125,589187,499974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]