SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509845 LIMIT 1 [ RunTime:0.001495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509845 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045398,302071,298734,1005307,944601,585165,760506,598072,338901,5686,529078,774557,255253,280736,832757,796238,795544,110789,72743,778960,415191,930650,522423,921632,390619,882364,983135,863224,96872,602349,190888,1030169,521046,34599,592188,401301,125647,605086,553824,279719,617109,482521,206652,442118,961401,747270,411825,581568,962129,730237,162964,326522,313559,792856,116582,476735,25564,7748,478815,123272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]