SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001699s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199614 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199614 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182400,301407,852903,421603,730382,342439,950456,315315,1039593,8596,29855,999086,538452,876615,890879,381477,761582,528703,454048,201538,375200,828810,847706,182443,126482,16478,737170,886192,717826,600435,977026,176820,805018,1038021,535329,387334,804014,511568,402176,559245,324592,13551,390970,4123,187465,435808,866885,712305,597286,81835,337483,681128,378820,334638,553942,424815,260522,684020,78475,451526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]