SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204698 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204698 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524200,705220,193634,283373,160156,636048,917581,620207,409057,187178,716129,655498,426446,623798,127918,818777,697481,189561,252930,597152,432927,630444,129919,648642,740070,1024656,513825,904436,766912,1045514,758620,664936,976065,567533,379245,46037,358061,525758,1025664,846703,81128,110120,516865,523135,983531,85521,368075,224027,218401,131228,190420,700424,242801,731476,604163,759320,1047059,162542,688586,453859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]