SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421211 LIMIT 1 [ RunTime:0.003865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421211 [ RunTime:0.005199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872611,288574,843226,31230,1036662,578998,322384,307630,4359,397392,243707,484721,569883,1003805,257006,843723,552342,726664,869622,587334,546340,367990,871727,852597,407017,283752,269623,349408,889566,36603,40686,15303,594866,355563,650371,239525,820177,609097,316274,311112,452205,821059,538397,950258,850970,662282,509333,740068,370283,433460,786024,773514,1001751,367478,1023948,549941,390548,993496,362698,481341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]