SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479244 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479244 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502990,100217,214310,161498,617261,225657,44985,618054,485082,923512,120969,533072,696965,662542,792271,417719,857065,624034,35628,277207,99867,557472,201885,220177,527091,708678,869226,1008893,437718,205572,638035,963506,220112,265448,642417,143750,415657,593462,1009526,338590,166132,552323,456378,163827,261507,325930,654327,37403,187195,789554,984112,143857,889258,471318,441955,1010479,648509,694170,947219,340407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]