SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313291 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313291 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155191,352050,661598,381567,800841,405697,432480,61953,1019963,820659,1044071,682019,133527,754008,252845,614486,963894,254018,647105,926144,314717,192911,277392,909143,276501,499191,787169,385371,997140,651382,755066,663834,858307,384585,535004,760991,844230,205223,375800,320391,464575,498031,27755,905632,12239,213375,564414,902208,989092,442097,572141,358499,728212,942323,325451,632402,704380,310822,149150,479234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]