SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501051 LIMIT 1 [ RunTime:0.002511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501051 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589780,186103,633215,303403,549207,687523,451278,551998,509221,910990,1038772,229901,26007,930931,888365,329366,58994,981542,842477,762035,648984,1028856,857114,29888,1011716,383239,678555,718828,708080,156812,925289,332372,167667,1029734,132120,709942,355806,17407,660852,719704,16730,74233,316173,505953,619206,189241,471100,512283,50078,788542,109079,152114,141016,1018049,43746,375584,377166,818692,139141,584655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]