SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318098 LIMIT 1 [ RunTime:0.001277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318098 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660524,868795,132584,314419,344162,297076,587613,572748,1047563,743185,78096,335104,741478,181595,939491,523982,2994,543506,175323,409646,672989,924158,51824,591967,709218,704031,576088,749229,610060,308641,622911,41509,290299,776943,796849,273650,909262,368182,853613,191731,402705,781071,246783,372959,420338,166634,645164,189915,225004,242442,1000094,718252,755865,999720,827516,822083,539005,750276,314018,728830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]