SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508185 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508185 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214800,640361,515864,400805,33672,1894,712833,59877,162331,951788,489340,445677,212514,316194,408645,74855,591071,579674,625477,539357,739786,134760,250299,235150,57471,633909,911555,264958,969527,837444,906215,861299,688505,153808,326615,486231,2732,581917,149161,718570,1019118,927094,559200,243014,205034,422915,206529,663482,26596,463407,93348,326996,206624,964084,755980,193457,747417,873113,83922,313747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]