SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409150 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409150 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254879,399080,495269,1011574,469559,367720,74462,235385,74695,139356,772372,252898,137638,1034758,106251,585022,114969,492315,240945,739981,263496,796152,529788,224622,721409,348336,95299,811632,231492,662556,875421,66985,178927,840462,286562,818229,121875,461487,16512,733441,806493,538352,138806,120644,51128,357189,405322,871735,145065,70126,179203,690106,117533,404633,457394,150466,184458,292633,45808,1032893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]