SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 13571 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 13571 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040226,919348,909534,313143,756920,464312,644117,386627,32507,314758,511929,353631,554161,648983,59196,139048,125779,1006519,404143,114874,469446,403503,663604,982012,260599,112156,741378,1008942,746865,966902,906905,179413,717369,1008190,904068,435686,19768,816758,773418,1013483,687417,993389,367475,168475,778100,395908,665514,822918,914905,433264,701220,108282,953440,260728,282191,241533,134579,802608,35346,545122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 13571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 13571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]