SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417988 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417988 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546481,39996,741608,525272,274583,158671,135405,1041878,954665,346188,10112,870054,295891,679849,911412,1039185,86243,988750,806650,942072,115521,783804,94174,983923,88961,248087,968106,121903,304457,201346,130181,846741,404152,198483,719086,495198,367651,866754,854853,640222,42397,231126,359360,168686,874251,469366,434612,407448,519254,661631,796576,413625,272598,914624,295313,194150,907484,365359,985319,382804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001241s ]