SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044015 LIMIT 1 [ RunTime:0.003847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044015 [ RunTime:0.005587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232250,288892,925918,332342,815720,668922,2984,943905,606368,755956,842003,522280,1017454,610821,72415,521372,177746,987977,824507,188916,791987,810822,298386,632646,489436,896283,549777,435620,725638,870912,917077,206691,654436,857431,639862,381203,275812,664813,666377,30691,290052,817166,775736,836475,780449,809722,222659,484327,924573,624987,328573,443388,495489,959445,817427,1017373,537503,790244,804776,99862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]