SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490404 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490404 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470743,747835,709925,826798,586536,695399,92626,778697,933732,204630,568846,671655,924196,412035,809748,400045,734844,84988,280643,264939,599757,121049,98816,11979,297019,990446,455312,566774,318121,570406,900163,425265,800341,211558,446375,433372,468941,866309,642860,924210,9016,959302,75958,1044750,298117,418908,129460,467497,906400,423464,991663,338294,249175,634423,474849,210798,152379,83031,815216,151245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]